Tabela Prescription

Definicja tabeli Prescription

Name

Prescription

Code

Prescription

Comment

Recepta


Lista kolumn tabeli Prescription

Name

Code

PrescriptionID

PrescriptionID

PrescriptionPermissionID

PrescriptionPermissionID

PrescriptionNo

PrescriptionNo

EventID

EventID

InsurID

InsurID

CountryID

CountryID

Active

Active

Printed

Printed

ExecutionStartDT

ExecutionStartDT

Uninsured

Uninsured

ChronicDisease

ChronicDisease

PatientComment

PatientComment

DrugsComment

DrugsComment

InsertingPerson

InsertingPerson

InsertDT

InsertDT

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT

OrderDT

OrderDT

BenefitProviderID

BenefitProviderID

OrderingPerson

OrderingPerson

PatientID

PatientID

PatientAddress

PatientAddress

PrescriptionTypeID

PrescriptionTypeID

PrescriptionNoSetID

PrescriptionNoSetID

DrugAccessCategoryID

DrugAccessCategoryID

PrescKindID

PrescKindID

PrescriptionStatusID

PrescriptionStatusID

BenefitProvider

BenefitProvider

DrugCount

DrugCount

DosageQuantity

DosageQuantity

DosageQuantityUnit

DosageQuantityUnit

LicenceNoBarCode

LicenceNoBarCode

CompanyStatisticalNoBarCode

CompanyStatisticalNoBarCode

NationalIDBarCode

NationalIDBarCode

PersonalIDNo

PersonalIDNo

TreatmentContinuation

TreatmentContinuation

ePrescription

ePrescription

PackageCode

PackageCode

PackageKey

PackageKey

ExecutionStopDT

ExecutionStopDT


Kolumna PrescriptionID tabeli Prescription

Definicja kolumny PrescriptionID tabeli Prescription

Name

PrescriptionID

Code

PrescriptionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PrescriptionPermissionID tabeli Prescription

Definicja kolumny PrescriptionPermissionID tabeli Prescription

Name

PrescriptionPermissionID

Code

PrescriptionPermissionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PrescriptionNo tabeli Prescription

Definicja kolumny PrescriptionNo tabeli Prescription

Name

PrescriptionNo

Code

PrescriptionNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer recepty


Kolumna EventID tabeli Prescription

Definicja kolumny EventID tabeli Prescription

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsurID tabeli Prescription

Definicja kolumny InsurID tabeli Prescription

Name

InsurID

Code

InsurID

Data Type

NUMBER(10)

Mandatory

No

Comment

depreciated


Kolumna CountryID tabeli Prescription

Definicja kolumny CountryID tabeli Prescription

Name

CountryID

Code

CountryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Prescription

Definicja kolumny Active tabeli Prescription

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna Printed tabeli Prescription

Definicja kolumny Printed tabeli Prescription

Name

Printed

Code

Printed

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Jesli zostal wcisniety przycisk wydruku recepty, flaga jest ustawiana na true.


Kolumna ExecutionStartDT tabeli Prescription

Definicja kolumny ExecutionStartDT tabeli Prescription

Name

ExecutionStartDT

Code

ExecutionStartDT

Data Type

DATE

Mandatory

No

Comment

Data realizacji od dnia


Kolumna Uninsured tabeli Prescription

Definicja kolumny Uninsured tabeli Prescription

Name

Uninsured

Code

Uninsured

Data Type

NUMBER(5)

Mandatory

No

Comment

Oddzial NFZ: nieubezpieczony (X)


Kolumna ChronicDisease tabeli Prescription

Definicja kolumny ChronicDisease tabeli Prescription

Name

ChronicDisease

Code

ChronicDisease

Data Type

VARCHAR2(10)

Mandatory

No

Comment

ch. przewlekla: X, P , P-EB


Kolumna PatientComment tabeli Prescription

Definicja kolumny PatientComment tabeli Prescription

Name

PatientComment

Code

PatientComment

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Komentarz na recepcie w sekcji pacjenta. Pro familia, pro auctore.


Kolumna DrugsComment tabeli Prescription

Definicja kolumny DrugsComment tabeli Prescription

Name

DrugsComment

Code

DrugsComment

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Komentarz na recepcie w sekcji leki . Np. Cito.


Kolumna InsertingPerson tabeli Prescription

Definicja kolumny InsertingPerson tabeli Prescription

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsertDT tabeli Prescription

Definicja kolumny InsertDT tabeli Prescription

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

Yes

Comment

Data dodania rekordu do bazy


Kolumna LastModifiedPerson tabeli Prescription

Definicja kolumny LastModifiedPerson tabeli Prescription

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LastModifiedDT tabeli Prescription

Definicja kolumny LastModifiedDT tabeli Prescription

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna OrderDT tabeli Prescription

Definicja kolumny OrderDT tabeli Prescription

Name

OrderDT

Code

OrderDT

Data Type

DATE

Mandatory

No

Comment

Data wystawienia


Kolumna BenefitProviderID tabeli Prescription

Definicja kolumny BenefitProviderID tabeli Prescription

Name

BenefitProviderID

Code

BenefitProviderID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingPerson tabeli Prescription

Definicja kolumny OrderingPerson tabeli Prescription

Name

OrderingPerson

Code

OrderingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientID tabeli Prescription

Definicja kolumny PatientID tabeli Prescription

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientAddress tabeli Prescription

Definicja kolumny PatientAddress tabeli Prescription

Name

PatientAddress

Code

PatientAddress

Data Type

VARCHAR2(256)

Mandatory

No

Comment

Adres pacjenta


Kolumna PrescriptionTypeID tabeli Prescription

Definicja kolumny PrescriptionTypeID tabeli Prescription

Name

PrescriptionTypeID

Code

PrescriptionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Typ recepty (recepta zwykla, nadruk, lista leków)


Kolumna PrescriptionNoSetID tabeli Prescription

Definicja kolumny PrescriptionNoSetID tabeli Prescription

Name

PrescriptionNoSetID

Code

PrescriptionNoSetID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pula recept wykorzystana do utworzenia recepty


Kolumna DrugAccessCategoryID tabeli Prescription

Definicja kolumny DrugAccessCategoryID tabeli Prescription

Name

DrugAccessCategoryID

Code

DrugAccessCategoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kategoria recepty


Kolumna PrescKindID tabeli Prescription

Definicja kolumny PrescKindID tabeli Prescription

Name

PrescKindID

Code

PrescKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

Rodzaj recepty
Przykladowe rodzaje:
LEK - lekarska
PIEL/POL - pielegniarek i poloznych


Kolumna PrescriptionStatusID tabeli Prescription

Definicja kolumny PrescriptionStatusID tabeli Prescription

Name

PrescriptionStatusID

Code

PrescriptionStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID statusu recepty


Kolumna BenefitProvider tabeli Prescription

Definicja kolumny BenefitProvider tabeli Prescription

Name

BenefitProvider

Code

BenefitProvider

Data Type

VARCHAR2(400)

Mandatory

No

Comment

Dane swiadczeniodawcy (zmaterializowane)


Kolumna DrugCount tabeli Prescription

Definicja kolumny DrugCount tabeli Prescription

Name

DrugCount

Code

DrugCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DosageQuantity tabeli Prescription

Definicja kolumny DosageQuantity tabeli Prescription

Name

DosageQuantity

Code

DosageQuantity

Data Type

NUMBER(18,8)

Mandatory

No

Comment

 


Kolumna DosageQuantityUnit tabeli Prescription

Definicja kolumny DosageQuantityUnit tabeli Prescription

Name

DosageQuantityUnit

Code

DosageQuantityUnit

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna LicenceNoBarCode tabeli Prescription

Definicja kolumny LicenceNoBarCode tabeli Prescription

Name

LicenceNoBarCode

Code

LicenceNoBarCode

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Wartosc kodu kreskowego numeru PWZ


Kolumna CompanyStatisticalNoBarCode tabeli Prescription

Definicja kolumny CompanyStatisticalNoBarCode tabeli Prescription

Name

CompanyStatisticalNoBarCode

Code

CompanyStatisticalNoBarCode

Data Type

VARCHAR2(14)

Mandatory

No

Comment

Wartosc kodu kreskowego identyfikatora os uprawnionej do wystawiania recept (numer nadany przez NFZ) lub swiadczeniodawcy (regon)


Kolumna NationalIDBarCode tabeli Prescription

Definicja kolumny NationalIDBarCode tabeli Prescription

Name

NationalIDBarCode

Code

NationalIDBarCode

Data Type

VARCHAR2(12)

Mandatory

No

Comment

Wartosc kodu kreskowego PESEL


Kolumna PersonalIDNo tabeli Prescription

Definicja kolumny PersonalIDNo tabeli Prescription

Name

PersonalIDNo

Code

PersonalIDNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Informacje o numerze pesel lub numerze poswiadczenia i numerze dok. tozsamosci


Kolumna TreatmentContinuation tabeli Prescription

Definicja kolumny TreatmentContinuation tabeli Prescription

Name

TreatmentContinuation

Code

TreatmentContinuation

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga informujaca o tym czy recepta dotyczy kontynuacji leczenia czy ordynacji samodzielnej


Kolumna ePrescription tabeli Prescription

Definicja kolumny ePrescription tabeli Prescription

Name

ePrescription

Code

ePrescription

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Recepta czy E-Recepta


Kolumna PackageCode tabeli Prescription

Definicja kolumny PackageCode tabeli Prescription

Name

PackageCode

Code

PackageCode

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Kod pakietu dla eRecepty


Kolumna PackageKey tabeli Prescription

Definicja kolumny PackageKey tabeli Prescription

Name

PackageKey

Code

PackageKey

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Klucz pakietu dla eRecepty


Kolumna ExecutionStopDT tabeli Prescription

Definicja kolumny ExecutionStopDT tabeli Prescription

Name

ExecutionStopDT

Code

ExecutionStopDT

Data Type

DATE

Mandatory

No

Comment

Data konca waznosci recepty


Lista kluczy tabeli Prescription

Name

Code

Primary

PK_Prescription

PK_Prescription

X


Klucz PK_Prescription tabeli Prescription

Definicja klucza PK_Prescription tabeli Prescription

Name

PK_Prescription

Code

PK_Prescription

Primary

Yes

Comment